Overview
Dataset statistics
| Number of variables | 35 |
|---|---|
| Number of observations | 88003 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.5 MiB |
| Average record size in memory | 280.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Text | 10 |
| Categorical | 9 |
| DateTime | 3 |
address_id is highly overall correlated with customer_id and 1 other fields | High correlation |
amount is highly overall correlated with rental_rate | High correlation |
customer_id is highly overall correlated with address_id and 1 other fields | High correlation |
film_id is highly overall correlated with inventory_id | High correlation |
inventory_id is highly overall correlated with film_id | High correlation |
payment_id is highly overall correlated with address_id and 1 other fields | High correlation |
rental_rate is highly overall correlated with amount | High correlation |
staff_fn is highly overall correlated with staff_id and 2 other fields | High correlation |
staff_id is highly overall correlated with staff_fn and 2 other fields | High correlation |
staff_ln is highly overall correlated with staff_fn and 2 other fields | High correlation |
store_id is highly overall correlated with staff_fn and 2 other fields | High correlation |
active is highly imbalanced (82.7%) | Imbalance |
Reproduction
| Analysis started | 2026-01-26 07:06:05.411937 |
|---|---|
| Analysis finished | 2026-01-26 07:06:14.910463 |
| Duration | 9.5 seconds |
| Software version | ydata-profiling vv4.18.1 |
| Download configuration | config.json |
Variables
film_id
Real number (ℝ)
High correlation
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 502.01051 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 255 |
| median | 496 |
| Q3 | 752 |
| 95-th percentile | 952 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 497 |
Descriptive statistics
| Standard deviation | 288.36419 |
|---|---|
| Coefficient of variation (CV) | 0.57441863 |
| Kurtosis | -1.1874154 |
| Mean | 502.01051 |
| Median Absolute Deviation (MAD) | 247 |
| Skewness | -0.010096326 |
| Sum | 44178431 |
| Variance | 83153.907 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 489 | 288 | 0.3% |
| 892 | 276 | 0.3% |
| 880 | 275 | 0.3% |
| 249 | 273 | 0.3% |
| 649 | 264 | 0.3% |
| 301 | 261 | 0.3% |
| 764 | 252 | 0.3% |
| 369 | 248 | 0.3% |
| 418 | 248 | 0.3% |
| 966 | 240 | 0.3% |
| Other values (945) | 85378 |
| Value | Count | Frequency (%) |
| 1 | 230 | |
| 2 | 28 | < 0.1% |
| 3 | 60 | 0.1% |
| 4 | 115 | |
| 5 | 60 | 0.1% |
| 6 | 147 | |
| 7 | 75 | 0.1% |
| 8 | 72 | 0.1% |
| 9 | 108 | |
| 10 | 184 |
| Value | Count | Frequency (%) |
| 1000 | 93 | |
| 999 | 85 | |
| 998 | 54 | 0.1% |
| 997 | 30 | < 0.1% |
| 996 | 35 | < 0.1% |
| 995 | 23 | < 0.1% |
| 994 | 78 | |
| 993 | 180 | |
| 992 | 56 | 0.1% |
| 991 | 64 | 0.1% |
title
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 14.314387 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PATIENT SISTER |
|---|---|
| 2nd row | PATIENT SISTER |
| 3rd row | PATIENT SISTER |
| 4th row | PATIENT SISTER |
| 5th row | TALENTED HOMICIDE |
| Value | Count | Frequency (%) |
| heartbreakers | 659 | 0.4% |
| boondock | 655 | 0.4% |
| armageddon | 647 | 0.4% |
| hellfighters | 642 | 0.4% |
| apollo | 625 | 0.4% |
| polish | 597 | 0.3% |
| shakespeare | 576 | 0.3% |
| desire | 568 | 0.3% |
| instinct | 558 | 0.3% |
| love | 548 | 0.3% |
| Other values (974) | 169931 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 124786 | 9.9% |
| A | 106224 | 8.4% |
| R | 91956 | 7.3% |
| O | 88848 | 7.1% |
| 88003 | 7.0% | |
| N | 83362 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72889 | 5.8% |
| L | 60404 | 4.8% |
| Other values (17) | 381520 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1259709 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 124786 | 9.9% |
| A | 106224 | 8.4% |
| R | 91956 | 7.3% |
| O | 88848 | 7.1% |
| 88003 | 7.0% | |
| N | 83362 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72889 | 5.8% |
| L | 60404 | 4.8% |
| Other values (17) | 381520 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1259709 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 124786 | 9.9% |
| A | 106224 | 8.4% |
| R | 91956 | 7.3% |
| O | 88848 | 7.1% |
| 88003 | 7.0% | |
| N | 83362 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72889 | 5.8% |
| L | 60404 | 4.8% |
| Other values (17) | 381520 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1259709 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 124786 | 9.9% |
| A | 106224 | 8.4% |
| R | 91956 | 7.3% |
| O | 88848 | 7.1% |
| 88003 | 7.0% | |
| N | 83362 | 6.6% |
| I | 83028 | 6.6% |
| S | 78689 | 6.2% |
| T | 72889 | 5.8% |
| L | 60404 | 4.8% |
| Other values (17) | 381520 |
description
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 130 |
|---|---|
| Median length | 115 |
| Mean length | 94.30574 |
| Min length | 70 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia |
|---|---|
| 2nd row | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia |
| 3rd row | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia |
| 4th row | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia |
| 5th row | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat |
| Value | Count | Frequency (%) |
| a | 388644 | |
| of | 91053 | 5.6% |
| and | 88003 | 5.4% |
| who | 88003 | 5.4% |
| must | 88003 | 5.4% |
| in | 88003 | 5.4% |
| the | 16917 | 1.0% |
| mad | 15834 | 1.0% |
| shark | 10686 | 0.7% |
| boat | 10387 | 0.6% |
| Other values (139) | 731780 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1529310 | ||
| a | 727487 | 8.8% |
| n | 572021 | 6.9% |
| o | 508454 | 6.1% |
| e | 496140 | 6.0% |
| t | 473395 | 5.7% |
| i | 421059 | 5.1% |
| r | 339854 | 4.1% |
| s | 298869 | 3.6% |
| A | 286081 | 3.4% |
| Other values (42) | 2646518 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8299188 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1529310 | ||
| a | 727487 | 8.8% |
| n | 572021 | 6.9% |
| o | 508454 | 6.1% |
| e | 496140 | 6.0% |
| t | 473395 | 5.7% |
| i | 421059 | 5.1% |
| r | 339854 | 4.1% |
| s | 298869 | 3.6% |
| A | 286081 | 3.4% |
| Other values (42) | 2646518 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8299188 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1529310 | ||
| a | 727487 | 8.8% |
| n | 572021 | 6.9% |
| o | 508454 | 6.1% |
| e | 496140 | 6.0% |
| t | 473395 | 5.7% |
| i | 421059 | 5.1% |
| r | 339854 | 4.1% |
| s | 298869 | 3.6% |
| A | 286081 | 3.4% |
| Other values (42) | 2646518 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8299188 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1529310 | ||
| a | 727487 | 8.8% |
| n | 572021 | 6.9% |
| o | 508454 | 6.1% |
| e | 496140 | 6.0% |
| t | 473395 | 5.7% |
| i | 421059 | 5.1% |
| r | 339854 | 4.1% |
| s | 298869 | 3.6% |
| A | 286081 | 3.4% |
| Other values (42) | 2646518 |
rental_duration
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| 6 | |
|---|---|
| 4 | |
| 3 | |
| 5 | |
| 7 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7 |
|---|---|
| 2nd row | 7 |
| 3rd row | 7 |
| 4th row | 7 |
| 5th row | 6 |
Common Values
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6 | 19279 | |
| 4 | 18643 | |
| 3 | 18215 | |
| 5 | 17551 | |
| 7 | 14315 |
rental_rate
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| 0.99 | |
|---|---|
| 2.99 | |
| 4.99 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.99 |
|---|---|
| 2nd row | 0.99 |
| 3rd row | 0.99 |
| 4th row | 0.99 |
| 5th row | 0.99 |
Common Values
| Value | Count | Frequency (%) |
| 0.99 | 31137 | |
| 2.99 | 28959 | |
| 4.99 | 27907 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.99 | 31137 | |
| 2.99 | 28959 | |
| 4.99 | 27907 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 176006 | |
| . | 88003 | |
| 0 | 31137 | 8.8% |
| 2 | 28959 | 8.2% |
| 4 | 27907 | 7.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 352012 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 176006 | |
| . | 88003 | |
| 0 | 31137 | 8.8% |
| 2 | 28959 | 8.2% |
| 4 | 27907 | 7.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 352012 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 176006 | |
| . | 88003 | |
| 0 | 31137 | 8.8% |
| 2 | 28959 | 8.2% |
| 4 | 27907 | 7.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 352012 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 176006 | |
| . | 88003 | |
| 0 | 31137 | 8.8% |
| 2 | 28959 | 8.2% |
| 4 | 27907 | 7.9% |
length
Real number (ℝ)
| Distinct | 140 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.10804 |
| Minimum | 46 |
|---|---|
| Maximum | 185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 80 |
| median | 114 |
| Q3 | 150 |
| 95-th percentile | 178 |
| Maximum | 185 |
| Range | 139 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 40.497718 |
|---|---|
| Coefficient of variation (CV) | 0.35182354 |
| Kurtosis | -1.1972212 |
| Mean | 115.10804 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 0.027207201 |
| Sum | 10129853 |
| Variance | 1640.0652 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85 | 1495 | 1.7% |
| 112 | 1358 | 1.5% |
| 178 | 1355 | 1.5% |
| 84 | 1178 | 1.3% |
| 80 | 1072 | 1.2% |
| 63 | 1070 | 1.2% |
| 75 | 1056 | 1.2% |
| 92 | 1041 | 1.2% |
| 179 | 1019 | 1.2% |
| 161 | 1008 | 1.1% |
| Other values (130) | 76351 |
| Value | Count | Frequency (%) |
| 46 | 585 | |
| 47 | 732 | |
| 48 | 832 | |
| 49 | 369 | |
| 50 | 563 | |
| 51 | 647 | |
| 52 | 704 | |
| 53 | 759 | |
| 54 | 524 | |
| 55 | 336 |
| Value | Count | Frequency (%) |
| 185 | 936 | |
| 184 | 393 | 0.4% |
| 183 | 417 | 0.5% |
| 182 | 252 | 0.3% |
| 181 | 837 | |
| 180 | 376 | 0.4% |
| 179 | 1019 | |
| 178 | 1355 | |
| 177 | 660 | |
| 176 | 893 |
replacement_cost
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.190914 |
| Minimum | 9.99 |
|---|---|
| Maximum | 29.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 9.99 |
|---|---|
| 5-th percentile | 10.99 |
| Q1 | 14.99 |
| median | 20.99 |
| Q3 | 24.99 |
| 95-th percentile | 29.99 |
| Maximum | 29.99 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.0875717 |
|---|---|
| Coefficient of variation (CV) | 0.30150056 |
| Kurtosis | -1.2236016 |
| Mean | 20.190914 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.035295321 |
| Sum | 1776861 |
| Variance | 37.058529 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.99 | 5626 | 6.4% |
| 27.99 | 5215 | 5.9% |
| 12.99 | 5024 | 5.7% |
| 21.99 | 4902 | 5.6% |
| 14.99 | 4893 | 5.6% |
| 29.99 | 4686 | 5.3% |
| 20.99 | 4672 | 5.3% |
| 26.99 | 4264 | 4.8% |
| 13.99 | 4213 | 4.8% |
| 11.99 | 4167 | 4.7% |
| Other values (11) | 40341 |
| Value | Count | Frequency (%) |
| 9.99 | 3924 | |
| 10.99 | 3526 | |
| 11.99 | 4167 | |
| 12.99 | 5024 | |
| 13.99 | 4213 | |
| 14.99 | 4893 | |
| 15.99 | 3141 | |
| 16.99 | 3593 | |
| 17.99 | 3755 | |
| 18.99 | 3744 |
| Value | Count | Frequency (%) |
| 29.99 | 4686 | |
| 28.99 | 4080 | |
| 27.99 | 5215 | |
| 26.99 | 4264 | |
| 25.99 | 3727 | |
| 24.99 | 3431 | |
| 23.99 | 3870 | |
| 22.99 | 5626 | |
| 21.99 | 4902 | |
| 20.99 | 4672 |
rating
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| PG-13 | |
|---|---|
| PG | |
| NC-17 | |
| R | |
| G |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.8796518 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NC-17 |
|---|---|
| 2nd row | NC-17 |
| 3rd row | NC-17 |
| 4th row | NC-17 |
| 5th row | PG |
Common Values
| Value | Count | Frequency (%) |
| PG-13 | 19065 | |
| PG | 18635 | |
| NC-17 | 17630 | |
| R | 17210 | |
| G | 15463 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pg-13 | 19065 | |
| pg | 18635 | |
| nc-17 | 17630 | |
| r | 17210 | |
| g | 15463 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 53163 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 253418 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 53163 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 253418 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 53163 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 253418 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 53163 | |
| P | 37700 | |
| - | 36695 | |
| 1 | 36695 | |
| 3 | 19065 | 7.5% |
| N | 17630 | 7.0% |
| C | 17630 | 7.0% |
| 7 | 17630 | 7.0% |
| R | 17210 | 6.8% |
actor_id
Real number (ℝ)
| Distinct | 200 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.96492 |
| Minimum | 1 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 52 |
| median | 102 |
| Q3 | 149 |
| 95-th percentile | 191 |
| Maximum | 200 |
| Range | 199 |
| Interquartile range (IQR) | 97 |
Descriptive statistics
| Standard deviation | 56.908857 |
|---|---|
| Coefficient of variation (CV) | 0.56364979 |
| Kurtosis | -1.1749861 |
| Mean | 100.96492 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.0019690918 |
| Sum | 8885216 |
| Variance | 3238.618 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 107 | 753 | 0.9% |
| 181 | 678 | 0.8% |
| 198 | 675 | 0.8% |
| 144 | 654 | 0.7% |
| 102 | 640 | 0.7% |
| 60 | 612 | 0.7% |
| 150 | 611 | 0.7% |
| 37 | 605 | 0.7% |
| 23 | 604 | 0.7% |
| 90 | 599 | 0.7% |
| Other values (190) | 81572 |
| Value | Count | Frequency (%) |
| 1 | 305 | |
| 2 | 387 | |
| 3 | 311 | |
| 4 | 274 | |
| 5 | 496 | |
| 6 | 279 | |
| 7 | 479 | |
| 8 | 317 | |
| 9 | 381 | |
| 10 | 362 |
| Value | Count | Frequency (%) |
| 200 | 350 | |
| 199 | 255 | 0.3% |
| 198 | 675 | |
| 197 | 553 | |
| 196 | 450 | |
| 195 | 450 | |
| 194 | 380 | |
| 193 | 449 | |
| 192 | 458 | |
| 191 | 523 |
actor_fn
Text
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 5.3009897 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SEAN |
|---|---|
| 2nd row | MILLA |
| 3rd row | VAL |
| 4th row | LUCILLE |
| 5th row | JADA |
| Value | Count | Frequency (%) |
| penelope | 1661 | 1.9% |
| kenneth | 1643 | 1.9% |
| jayne | 1565 | 1.8% |
| matthew | 1518 | 1.7% |
| julia | 1435 | 1.6% |
| groucho | 1350 | 1.5% |
| morgan | 1340 | 1.5% |
| ed | 1311 | 1.5% |
| burt | 1309 | 1.5% |
| christian | 1286 | 1.5% |
| Other values (118) | 73585 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 65227 | |
| A | 52745 | 11.3% |
| R | 41096 | 8.8% |
| N | 40755 | 8.7% |
| L | 29594 | 6.3% |
| I | 29427 | 6.3% |
| O | 18598 | 4.0% |
| S | 18575 | 4.0% |
| T | 18157 | 3.9% |
| M | 17209 | 3.7% |
| Other values (14) | 135120 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 466503 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 65227 | |
| A | 52745 | 11.3% |
| R | 41096 | 8.8% |
| N | 40755 | 8.7% |
| L | 29594 | 6.3% |
| I | 29427 | 6.3% |
| O | 18598 | 4.0% |
| S | 18575 | 4.0% |
| T | 18157 | 3.9% |
| M | 17209 | 3.7% |
| Other values (14) | 135120 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 466503 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 65227 | |
| A | 52745 | 11.3% |
| R | 41096 | 8.8% |
| N | 40755 | 8.7% |
| L | 29594 | 6.3% |
| I | 29427 | 6.3% |
| O | 18598 | 4.0% |
| S | 18575 | 4.0% |
| T | 18157 | 3.9% |
| M | 17209 | 3.7% |
| Other values (14) | 135120 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 466503 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 65227 | |
| A | 52745 | 11.3% |
| R | 41096 | 8.8% |
| N | 40755 | 8.7% |
| L | 29594 | 6.3% |
| I | 29427 | 6.3% |
| O | 18598 | 4.0% |
| S | 18575 | 4.0% |
| T | 18157 | 3.9% |
| M | 17209 | 3.7% |
| Other values (14) | 135120 |
actor_ln
Text
| Distinct | 121 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 6.2453439 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | GUINESS |
|---|---|
| 2nd row | KEITEL |
| 3rd row | BOLGER |
| 4th row | TRACY |
| 5th row | RYDER |
| Value | Count | Frequency (%) |
| kilmer | 2145 | 2.4% |
| nolte | 2119 | 2.4% |
| temple | 1788 | 2.0% |
| degeneres | 1611 | 1.8% |
| keitel | 1587 | 1.8% |
| berry | 1480 | 1.7% |
| torn | 1478 | 1.7% |
| hoffman | 1455 | 1.7% |
| guiness | 1426 | 1.6% |
| garland | 1394 | 1.6% |
| Other values (111) | 71520 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 68637 | |
| N | 44882 | 8.2% |
| R | 41122 | 7.5% |
| A | 39731 | 7.2% |
| O | 39696 | 7.2% |
| L | 39456 | 7.2% |
| I | 33956 | 6.2% |
| S | 32309 | 5.9% |
| T | 23679 | 4.3% |
| D | 21504 | 3.9% |
| Other values (17) | 164637 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 549609 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 68637 | |
| N | 44882 | 8.2% |
| R | 41122 | 7.5% |
| A | 39731 | 7.2% |
| O | 39696 | 7.2% |
| L | 39456 | 7.2% |
| I | 33956 | 6.2% |
| S | 32309 | 5.9% |
| T | 23679 | 4.3% |
| D | 21504 | 3.9% |
| Other values (17) | 164637 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 549609 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 68637 | |
| N | 44882 | 8.2% |
| R | 41122 | 7.5% |
| A | 39731 | 7.2% |
| O | 39696 | 7.2% |
| L | 39456 | 7.2% |
| I | 33956 | 6.2% |
| S | 32309 | 5.9% |
| T | 23679 | 4.3% |
| D | 21504 | 3.9% |
| Other values (17) | 164637 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 549609 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 68637 | |
| N | 44882 | 8.2% |
| R | 41122 | 7.5% |
| A | 39731 | 7.2% |
| O | 39696 | 7.2% |
| L | 39456 | 7.2% |
| I | 33956 | 6.2% |
| S | 32309 | 5.9% |
| T | 23679 | 4.3% |
| D | 21504 | 3.9% |
| Other values (17) | 164637 |
customer_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 297.17848 |
| Minimum | 1 |
|---|---|
| Maximum | 599 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 148 |
| median | 296 |
| Q3 | 446 |
| 95-th percentile | 568 |
| Maximum | 599 |
| Range | 598 |
| Interquartile range (IQR) | 298 |
Descriptive statistics
| Standard deviation | 172.26314 |
|---|---|
| Coefficient of variation (CV) | 0.57966224 |
| Kurtosis | -1.1884762 |
| Mean | 297.17848 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.0088665271 |
| Sum | 26152598 |
| Variance | 29674.591 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 148 | 272 | 0.3% |
| 526 | 251 | 0.3% |
| 197 | 244 | 0.3% |
| 144 | 239 | 0.3% |
| 75 | 233 | 0.3% |
| 236 | 233 | 0.3% |
| 29 | 223 | 0.3% |
| 257 | 221 | 0.3% |
| 178 | 220 | 0.2% |
| 410 | 216 | 0.2% |
| Other values (589) | 85651 |
| Value | Count | Frequency (%) |
| 1 | 156 | |
| 2 | 175 | |
| 3 | 144 | |
| 4 | 121 | |
| 5 | 183 | |
| 6 | 171 | |
| 7 | 191 | |
| 8 | 152 | |
| 9 | 129 | |
| 10 | 123 |
| Value | Count | Frequency (%) |
| 599 | 102 | |
| 598 | 102 | |
| 597 | 144 | |
| 596 | 158 | |
| 595 | 141 | |
| 594 | 141 | |
| 593 | 129 | |
| 592 | 145 | |
| 591 | 120 | |
| 590 | 134 |
cust_fn
Text
| Distinct | 591 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.6736589 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MARY |
|---|---|
| 2nd row | MARY |
| 3rd row | MARY |
| 4th row | MARY |
| 5th row | MARY |
| Value | Count | Frequency (%) |
| marion | 388 | 0.4% |
| leslie | 325 | 0.4% |
| tracy | 303 | 0.3% |
| willie | 291 | 0.3% |
| terry | 291 | 0.3% |
| jessie | 290 | 0.3% |
| jamie | 277 | 0.3% |
| kelly | 272 | 0.3% |
| eleanor | 272 | 0.3% |
| karl | 251 | 0.3% |
| Other values (581) | 85043 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 62900 | |
| A | 61300 | |
| R | 47061 | 9.4% |
| N | 42781 | 8.6% |
| I | 38757 | 7.8% |
| L | 36735 | 7.4% |
| O | 23432 | 4.7% |
| T | 21523 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126309 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 499299 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 62900 | |
| A | 61300 | |
| R | 47061 | 9.4% |
| N | 42781 | 8.6% |
| I | 38757 | 7.8% |
| L | 36735 | 7.4% |
| O | 23432 | 4.7% |
| T | 21523 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126309 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 499299 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 62900 | |
| A | 61300 | |
| R | 47061 | 9.4% |
| N | 42781 | 8.6% |
| I | 38757 | 7.8% |
| L | 36735 | 7.4% |
| O | 23432 | 4.7% |
| T | 21523 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126309 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 499299 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 62900 | |
| A | 61300 | |
| R | 47061 | 9.4% |
| N | 42781 | 8.6% |
| I | 38757 | 7.8% |
| L | 36735 | 7.4% |
| O | 23432 | 4.7% |
| T | 21523 | 4.3% |
| S | 19614 | 3.9% |
| D | 18887 | 3.8% |
| Other values (16) | 126309 |
cust_ln
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 6.1921753 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SMITH |
|---|---|
| 2nd row | SMITH |
| 3rd row | SMITH |
| 4th row | SMITH |
| 5th row | SMITH |
| Value | Count | Frequency (%) |
| hunt | 272 | 0.3% |
| seal | 251 | 0.3% |
| peters | 244 | 0.3% |
| shaw | 239 | 0.3% |
| sanders | 233 | 0.3% |
| dean | 233 | 0.3% |
| hernandez | 223 | 0.3% |
| douglas | 221 | 0.3% |
| snyder | 220 | 0.2% |
| irby | 216 | 0.2% |
| Other values (589) | 85651 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 58281 | 10.7% |
| R | 54396 | 10.0% |
| A | 47366 | 8.7% |
| N | 43550 | 8.0% |
| O | 38964 | 7.2% |
| L | 38581 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26024 | 4.8% |
| H | 20092 | 3.7% |
| Other values (16) | 154843 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 544930 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 58281 | 10.7% |
| R | 54396 | 10.0% |
| A | 47366 | 8.7% |
| N | 43550 | 8.0% |
| O | 38964 | 7.2% |
| L | 38581 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26024 | 4.8% |
| H | 20092 | 3.7% |
| Other values (16) | 154843 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 544930 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 58281 | 10.7% |
| R | 54396 | 10.0% |
| A | 47366 | 8.7% |
| N | 43550 | 8.0% |
| O | 38964 | 7.2% |
| L | 38581 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26024 | 4.8% |
| H | 20092 | 3.7% |
| Other values (16) | 154843 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 544930 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 58281 | 10.7% |
| R | 54396 | 10.0% |
| A | 47366 | 8.7% |
| N | 43550 | 8.0% |
| O | 38964 | 7.2% |
| L | 38581 | 7.1% |
| S | 35961 | 6.6% |
| I | 26872 | 4.9% |
| T | 26024 | 4.8% |
| H | 20092 | 3.7% |
| Other values (16) | 154843 |
email
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 40 |
|---|---|
| Median length | 38 |
| Mean length | 31.865834 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MARY.SMITH@sakilacustomer.org |
|---|---|
| 2nd row | MARY.SMITH@sakilacustomer.org |
| 3rd row | MARY.SMITH@sakilacustomer.org |
| 4th row | MARY.SMITH@sakilacustomer.org |
| 5th row | MARY.SMITH@sakilacustomer.org |
| Value | Count | Frequency (%) |
| eleanor.hunt@sakilacustomer.org | 272 | 0.3% |
| karl.seal@sakilacustomer.org | 251 | 0.3% |
| sue.peters@sakilacustomer.org | 244 | 0.3% |
| clara.shaw@sakilacustomer.org | 239 | 0.3% |
| tammy.sanders@sakilacustomer.org | 233 | 0.3% |
| marcia.dean@sakilacustomer.org | 233 | 0.3% |
| angela.hernandez@sakilacustomer.org | 223 | 0.3% |
| marsha.douglas@sakilacustomer.org | 221 | 0.3% |
| marion.snyder@sakilacustomer.org | 220 | 0.2% |
| curtis.irby@sakilacustomer.org | 216 | 0.2% |
| Other values (589) | 85651 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 176006 | 6.3% |
| . | 176006 | 6.3% |
| o | 176006 | 6.3% |
| s | 176006 | 6.3% |
| a | 176006 | 6.3% |
| E | 121181 | 4.3% |
| A | 108666 | 3.9% |
| R | 101457 | 3.6% |
| l | 88003 | 3.1% |
| g | 88003 | 3.1% |
| Other values (31) | 1416949 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2804289 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 176006 | 6.3% |
| . | 176006 | 6.3% |
| o | 176006 | 6.3% |
| s | 176006 | 6.3% |
| a | 176006 | 6.3% |
| E | 121181 | 4.3% |
| A | 108666 | 3.9% |
| R | 101457 | 3.6% |
| l | 88003 | 3.1% |
| g | 88003 | 3.1% |
| Other values (31) | 1416949 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2804289 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 176006 | 6.3% |
| . | 176006 | 6.3% |
| o | 176006 | 6.3% |
| s | 176006 | 6.3% |
| a | 176006 | 6.3% |
| E | 121181 | 4.3% |
| A | 108666 | 3.9% |
| R | 101457 | 3.6% |
| l | 88003 | 3.1% |
| g | 88003 | 3.1% |
| Other values (31) | 1416949 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2804289 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 176006 | 6.3% |
| . | 176006 | 6.3% |
| o | 176006 | 6.3% |
| s | 176006 | 6.3% |
| a | 176006 | 6.3% |
| E | 121181 | 4.3% |
| A | 108666 | 3.9% |
| R | 101457 | 3.6% |
| l | 88003 | 3.1% |
| g | 88003 | 3.1% |
| Other values (31) | 1416949 |
active
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| 1 | |
|---|---|
| 0 | 2266 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 85737 | |
| 0 | 2266 | 2.6% |
rental_id
Real number (ℝ)
| Distinct | 16004 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8032.5002 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 816.1 |
| Q1 | 4026.5 |
| median | 8039 |
| Q3 | 12027 |
| 95-th percentile | 15247 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 8000.5 |
Descriptive statistics
| Standard deviation | 4631.7329 |
|---|---|
| Coefficient of variation (CV) | 0.57662407 |
| Kurtosis | -1.2006239 |
| Mean | 8032.5002 |
| Median Absolute Deviation (MAD) | 4002 |
| Skewness | -0.0011786957 |
| Sum | 7.0688411 × 108 |
| Variance | 21452950 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 20 | < 0.1% |
| 14200 | 15 | < 0.1% |
| 4845 | 15 | < 0.1% |
| 7446 | 15 | < 0.1% |
| 8014 | 15 | < 0.1% |
| 12701 | 15 | < 0.1% |
| 7152 | 15 | < 0.1% |
| 5930 | 15 | < 0.1% |
| 15187 | 15 | < 0.1% |
| 2796 | 15 | < 0.1% |
| Other values (15994) | 87848 |
| Value | Count | Frequency (%) |
| 1 | 20 | |
| 2 | 5 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 6 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 3 | < 0.1% |
| 10 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 16049 | 6 | |
| 16048 | 2 | < 0.1% |
| 16047 | 7 | |
| 16046 | 5 | |
| 16045 | 5 | |
| 16044 | 5 | |
| 16043 | 7 | |
| 16042 | 3 | < 0.1% |
| 16041 | 6 | |
| 16040 | 8 |
rental_date
Date
| Distinct | 15776 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2006-02-14 15:16:03 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
return_date
Date
| Distinct | 15796 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Minimum | 2005-05-25 23:55:21 |
|---|---|
| Maximum | 2005-09-02 02:35:22 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
payment_id
Real number (ℝ)
High correlation
| Distinct | 16009 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8026.4141 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 795.1 |
| Q1 | 4037.5 |
| median | 8034 |
| Q3 | 12029 |
| 95-th percentile | 15218 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 7991.5 |
Descriptive statistics
| Standard deviation | 4627.9028 |
|---|---|
| Coefficient of variation (CV) | 0.57658411 |
| Kurtosis | -1.1977652 |
| Mean | 8026.4141 |
| Median Absolute Deviation (MAD) | 3996 |
| Skewness | -0.0065076363 |
| Sum | 7.0634852 × 108 |
| Variance | 21417485 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 13129 | 15 | < 0.1% |
| 5662 | 15 | < 0.1% |
| 12463 | 15 | < 0.1% |
| 2280 | 15 | < 0.1% |
| 6853 | 15 | < 0.1% |
| 10004 | 15 | < 0.1% |
| 13202 | 15 | < 0.1% |
| 14839 | 15 | < 0.1% |
| 9457 | 15 | < 0.1% |
| 288 | 15 | < 0.1% |
| Other values (15999) | 87853 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 1 | < 0.1% |
| 4 | 3 | |
| 5 | 1 | < 0.1% |
| 6 | 6 | |
| 7 | 4 | |
| 8 | 6 | |
| 9 | 5 | |
| 10 | 5 |
| Value | Count | Frequency (%) |
| 16049 | 4 | |
| 16048 | 8 | |
| 16047 | 5 | |
| 16046 | 4 | |
| 16045 | 3 | < 0.1% |
| 16044 | 5 | |
| 16043 | 3 | < 0.1% |
| 16042 | 5 | |
| 16041 | 9 | |
| 16040 | 6 |
amount
Real number (ℝ)
High correlation
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1771512 |
| Minimum | 0 |
|---|---|
| Maximum | 11.99 |
| Zeros | 133 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.99 |
| Q1 | 2.99 |
| median | 3.99 |
| Q3 | 4.99 |
| 95-th percentile | 8.99 |
| Maximum | 11.99 |
| Range | 11.99 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.3456479 |
|---|---|
| Coefficient of variation (CV) | 0.56154248 |
| Kurtosis | -0.24037839 |
| Mean | 4.1771512 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.46837152 |
| Sum | 367601.84 |
| Variance | 5.502064 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 20434 | |
| 2.99 | 19873 | |
| 0.99 | 16275 | |
| 5.99 | 7181 | 8.2% |
| 3.99 | 6354 | 7.2% |
| 6.99 | 5929 | 6.7% |
| 7.99 | 3654 | 4.2% |
| 1.99 | 3498 | 4.0% |
| 8.99 | 2633 | 3.0% |
| 9.99 | 1302 | 1.5% |
| Other values (9) | 870 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 133 | 0.2% |
| 0.99 | 16275 | |
| 1.98 | 4 | < 0.1% |
| 1.99 | 3498 | 4.0% |
| 2.99 | 19873 | |
| 3.98 | 43 | < 0.1% |
| 3.99 | 6354 | 7.2% |
| 4.99 | 20434 | |
| 5.98 | 47 | 0.1% |
| 5.99 | 7181 | 8.2% |
| Value | Count | Frequency (%) |
| 11.99 | 49 | 0.1% |
| 10.99 | 549 | 0.6% |
| 9.99 | 1302 | 1.5% |
| 9.98 | 6 | < 0.1% |
| 8.99 | 2633 | 3.0% |
| 8.97 | 7 | < 0.1% |
| 7.99 | 3654 | |
| 7.98 | 32 | < 0.1% |
| 6.99 | 5929 | |
| 5.99 | 7181 |
payment_date
Date
| Distinct | 15780 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2006-02-14 15:16:03 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
inventory_id
Real number (ℝ)
High correlation
| Distinct | 4567 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2296.0328 |
| Minimum | 1 |
|---|---|
| Maximum | 4581 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 214 |
| Q1 | 1158 |
| median | 2287 |
| Q3 | 3428 |
| 95-th percentile | 4367 |
| Maximum | 4581 |
| Range | 4580 |
| Interquartile range (IQR) | 2270 |
Descriptive statistics
| Standard deviation | 1321.4595 |
|---|---|
| Coefficient of variation (CV) | 0.57554035 |
| Kurtosis | -1.1822263 |
| Mean | 2296.0328 |
| Median Absolute Deviation (MAD) | 1134 |
| Skewness | -0.0059873723 |
| Sum | 2.0205778 × 108 |
| Variance | 1746255.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1122 | 65 | 0.1% |
| 1123 | 65 | 0.1% |
| 2423 | 60 | 0.1% |
| 1899 | 60 | 0.1% |
| 158 | 60 | 0.1% |
| 2337 | 60 | 0.1% |
| 4095 | 60 | 0.1% |
| 2371 | 60 | 0.1% |
| 2424 | 60 | 0.1% |
| 3328 | 55 | 0.1% |
| Other values (4557) | 87398 |
| Value | Count | Frequency (%) |
| 1 | 30 | |
| 2 | 50 | |
| 3 | 20 | < 0.1% |
| 4 | 20 | < 0.1% |
| 6 | 50 | |
| 7 | 40 | |
| 8 | 20 | < 0.1% |
| 9 | 8 | < 0.1% |
| 10 | 12 | < 0.1% |
| 11 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 4581 | 15 | |
| 4580 | 6 | < 0.1% |
| 4579 | 15 | |
| 4578 | 9 | < 0.1% |
| 4577 | 15 | |
| 4576 | 12 | |
| 4575 | 12 | |
| 4574 | 9 | < 0.1% |
| 4573 | 25 | |
| 4572 | 20 |
store_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
staff_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88003 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 47969 | |
| 2 | 40034 |
staff_fn
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Mike | |
|---|---|
| Jon |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.5450837 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mike |
|---|---|
| 2nd row | Mike |
| 3rd row | Mike |
| 4th row | Mike |
| 5th row | Mike |
Common Values
| Value | Count | Frequency (%) |
| Mike | 47969 | |
| Jon | 40034 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mike | 47969 | |
| jon | 40034 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 47969 | |
| i | 47969 | |
| k | 47969 | |
| e | 47969 | |
| J | 40034 | |
| o | 40034 | |
| n | 40034 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 311978 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 47969 | |
| i | 47969 | |
| k | 47969 | |
| e | 47969 | |
| J | 40034 | |
| o | 40034 | |
| n | 40034 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 311978 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 47969 | |
| i | 47969 | |
| k | 47969 | |
| e | 47969 | |
| J | 40034 | |
| o | 40034 | |
| n | 40034 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 311978 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 47969 | |
| i | 47969 | |
| k | 47969 | |
| e | 47969 | |
| J | 40034 | |
| o | 40034 | |
| n | 40034 |
staff_ln
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Hillyer | |
|---|---|
| Stephens |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.4549163 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hillyer |
|---|---|
| 2nd row | Hillyer |
| 3rd row | Hillyer |
| 4th row | Hillyer |
| 5th row | Hillyer |
Common Values
| Value | Count | Frequency (%) |
| Hillyer | 47969 | |
| Stephens | 40034 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hillyer | 47969 | |
| stephens | 40034 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 128037 | |
| l | 95938 | |
| H | 47969 | 7.3% |
| i | 47969 | 7.3% |
| y | 47969 | 7.3% |
| r | 47969 | 7.3% |
| S | 40034 | 6.1% |
| t | 40034 | 6.1% |
| p | 40034 | 6.1% |
| h | 40034 | 6.1% |
| Other values (2) | 80068 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 656055 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 128037 | |
| l | 95938 | |
| H | 47969 | 7.3% |
| i | 47969 | 7.3% |
| y | 47969 | 7.3% |
| r | 47969 | 7.3% |
| S | 40034 | 6.1% |
| t | 40034 | 6.1% |
| p | 40034 | 6.1% |
| h | 40034 | 6.1% |
| Other values (2) | 80068 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 656055 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 128037 | |
| l | 95938 | |
| H | 47969 | 7.3% |
| i | 47969 | 7.3% |
| y | 47969 | 7.3% |
| r | 47969 | 7.3% |
| S | 40034 | 6.1% |
| t | 40034 | 6.1% |
| p | 40034 | 6.1% |
| h | 40034 | 6.1% |
| Other values (2) | 80068 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 656055 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 128037 | |
| l | 95938 | |
| H | 47969 | 7.3% |
| i | 47969 | 7.3% |
| y | 47969 | 7.3% |
| r | 47969 | 7.3% |
| S | 40034 | 6.1% |
| t | 40034 | 6.1% |
| p | 40034 | 6.1% |
| h | 40034 | 6.1% |
| Other values (2) | 80068 |
address_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 301.89364 |
| Minimum | 5 |
|---|---|
| Maximum | 605 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 152 |
| median | 301 |
| Q3 | 451 |
| 95-th percentile | 574 |
| Maximum | 605 |
| Range | 600 |
| Interquartile range (IQR) | 299 |
Descriptive statistics
| Standard deviation | 172.89386 |
|---|---|
| Coefficient of variation (CV) | 0.57269791 |
| Kurtosis | -1.188725 |
| Mean | 301.89364 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.010566113 |
| Sum | 26567546 |
| Variance | 29892.286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 152 | 272 | 0.3% |
| 532 | 251 | 0.3% |
| 201 | 244 | 0.3% |
| 148 | 239 | 0.3% |
| 79 | 233 | 0.3% |
| 240 | 233 | 0.3% |
| 33 | 223 | 0.3% |
| 262 | 221 | 0.3% |
| 182 | 220 | 0.2% |
| 415 | 216 | 0.2% |
| Other values (589) | 85651 |
| Value | Count | Frequency (%) |
| 5 | 156 | |
| 6 | 175 | |
| 7 | 144 | |
| 8 | 121 | |
| 9 | 183 | |
| 10 | 171 | |
| 11 | 191 | |
| 12 | 152 | |
| 13 | 129 | |
| 14 | 123 |
| Value | Count | Frequency (%) |
| 605 | 102 | |
| 604 | 102 | |
| 603 | 144 | |
| 602 | 158 | |
| 601 | 141 | |
| 600 | 141 | |
| 599 | 129 | |
| 598 | 145 | |
| 597 | 120 | |
| 596 | 134 |
address
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 38 |
|---|---|
| Median length | 34 |
| Mean length | 19.461007 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1913 Hanoi Way |
|---|---|
| 2nd row | 1913 Hanoi Way |
| 3rd row | 1913 Hanoi Way |
| 4th row | 1913 Hanoi Way |
| 5th row | 1913 Hanoi Way |
| Value | Count | Frequency (%) |
| parkway | 11137 | 3.9% |
| manor | 9908 | 3.4% |
| avenue | 8963 | 3.1% |
| way | 8854 | 3.1% |
| lane | 8768 | 3.0% |
| street | 8622 | 3.0% |
| place | 8225 | 2.8% |
| loop | 8071 | 2.8% |
| boulevard | 7812 | 2.7% |
| drive | 7643 | 2.6% |
| Other values (957) | 201269 |
Most occurring characters
| Value | Count | Frequency (%) |
| 201269 | 11.8% | |
| a | 179026 | 10.5% |
| e | 110215 | 6.4% |
| o | 87025 | 5.1% |
| r | 83511 | 4.9% |
| n | 82203 | 4.8% |
| 1 | 67763 | 4.0% |
| i | 51598 | 3.0% |
| l | 51231 | 3.0% |
| u | 49057 | 2.9% |
| Other values (56) | 749729 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1712627 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 201269 | 11.8% | |
| a | 179026 | 10.5% |
| e | 110215 | 6.4% |
| o | 87025 | 5.1% |
| r | 83511 | 4.9% |
| n | 82203 | 4.8% |
| 1 | 67763 | 4.0% |
| i | 51598 | 3.0% |
| l | 51231 | 3.0% |
| u | 49057 | 2.9% |
| Other values (56) | 749729 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1712627 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 201269 | 11.8% | |
| a | 179026 | 10.5% |
| e | 110215 | 6.4% |
| o | 87025 | 5.1% |
| r | 83511 | 4.9% |
| n | 82203 | 4.8% |
| 1 | 67763 | 4.0% |
| i | 51598 | 3.0% |
| l | 51231 | 3.0% |
| u | 49057 | 2.9% |
| Other values (56) | 749729 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1712627 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 201269 | 11.8% | |
| a | 179026 | 10.5% |
| e | 110215 | 6.4% |
| o | 87025 | 5.1% |
| r | 83511 | 4.9% |
| n | 82203 | 4.8% |
| 1 | 67763 | 4.0% |
| i | 51598 | 3.0% |
| l | 51231 | 3.0% |
| u | 49057 | 2.9% |
| Other values (56) | 749729 |
postal_code
Real number (ℝ)
| Distinct | 596 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50338.395 |
| Minimum | 3 |
|---|---|
| Maximum | 99865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4855 |
| Q1 | 25220 |
| median | 50805 |
| Q3 | 74750 |
| 95-th percentile | 95509 |
| Maximum | 99865 |
| Range | 99862 |
| Interquartile range (IQR) | 49530 |
Descriptive statistics
| Standard deviation | 28837.245 |
|---|---|
| Coefficient of variation (CV) | 0.5728678 |
| Kurtosis | -1.1638411 |
| Mean | 50338.395 |
| Median Absolute Deviation (MAD) | 24669 |
| Skewness | -0.019266617 |
| Sum | 4.4299297 × 109 |
| Variance | 8.3158673 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52137 | 299 | 0.3% |
| 9668 | 284 | 0.3% |
| 92150 | 272 | 0.3% |
| 22474 | 270 | 0.3% |
| 31342 | 251 | 0.3% |
| 89459 | 244 | 0.3% |
| 30861 | 239 | 0.3% |
| 72394 | 233 | 0.3% |
| 18727 | 233 | 0.3% |
| 65750 | 223 | 0.3% |
| Other values (586) | 85455 |
| Value | Count | Frequency (%) |
| 3 | 122 | |
| 400 | 138 | |
| 504 | 130 | |
| 841 | 108 | |
| 943 | 133 | |
| 966 | 118 | |
| 1027 | 132 | |
| 1079 | 122 | |
| 1195 | 146 | |
| 1545 | 190 |
| Value | Count | Frequency (%) |
| 99865 | 126 | |
| 99780 | 165 | |
| 99552 | 156 | |
| 99457 | 168 | |
| 99405 | 178 | |
| 99124 | 124 | |
| 98889 | 141 | |
| 98883 | 164 | |
| 98775 | 121 | |
| 98573 | 157 |
city_id
Real number (ℝ)
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 301.38698 |
| Minimum | 1 |
|---|---|
| Maximum | 600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 148 |
| median | 304 |
| Q3 | 452 |
| 95-th percentile | 569 |
| Maximum | 600 |
| Range | 599 |
| Interquartile range (IQR) | 304 |
Descriptive statistics
| Standard deviation | 173.50356 |
|---|---|
| Coefficient of variation (CV) | 0.57568368 |
| Kurtosis | -1.2104514 |
| Mean | 301.38698 |
| Median Absolute Deviation (MAD) | 152 |
| Skewness | -0.016064084 |
| Sum | 26522958 |
| Variance | 30103.486 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42 | 275 | 0.3% |
| 442 | 272 | 0.3% |
| 312 | 271 | 0.3% |
| 101 | 251 | 0.3% |
| 109 | 244 | 0.3% |
| 340 | 239 | 0.3% |
| 108 | 233 | 0.3% |
| 527 | 233 | 0.3% |
| 474 | 223 | 0.3% |
| 64 | 221 | 0.3% |
| Other values (587) | 85541 |
| Value | Count | Frequency (%) |
| 1 | 156 | |
| 2 | 124 | |
| 3 | 177 | |
| 4 | 160 | |
| 5 | 131 | |
| 6 | 123 | |
| 7 | 178 | |
| 8 | 136 | |
| 9 | 164 | |
| 10 | 157 |
| Value | Count | Frequency (%) |
| 600 | 131 | |
| 599 | 171 | |
| 598 | 157 | |
| 597 | 138 | |
| 596 | 153 | |
| 595 | 81 | |
| 594 | 123 | |
| 593 | 144 | |
| 592 | 139 | |
| 591 | 137 |
city
Text
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 21 |
| Mean length | 8.3923616 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sasebo |
|---|---|
| 2nd row | Sasebo |
| 3rd row | Sasebo |
| 4th row | Sasebo |
| 5th row | Sasebo |
| Value | Count | Frequency (%) |
| de | 1936 | 1.8% |
| san | 946 | 0.9% |
| la | 727 | 0.7% |
| del | 581 | 0.5% |
| santa | 578 | 0.5% |
| el | 433 | 0.4% |
| hill | 411 | 0.4% |
| santiago | 395 | 0.4% |
| plata | 353 | 0.3% |
| felipe | 344 | 0.3% |
| Other values (673) | 100711 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 109633 | 14.8% |
| n | 52078 | 7.1% |
| o | 47635 | 6.4% |
| i | 46556 | 6.3% |
| e | 42704 | 5.8% |
| r | 38393 | 5.2% |
| u | 34239 | 4.6% |
| l | 30362 | 4.1% |
| s | 24885 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287415 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 738553 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 109633 | 14.8% |
| n | 52078 | 7.1% |
| o | 47635 | 6.4% |
| i | 46556 | 6.3% |
| e | 42704 | 5.8% |
| r | 38393 | 5.2% |
| u | 34239 | 4.6% |
| l | 30362 | 4.1% |
| s | 24885 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287415 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 738553 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 109633 | 14.8% |
| n | 52078 | 7.1% |
| o | 47635 | 6.4% |
| i | 46556 | 6.3% |
| e | 42704 | 5.8% |
| r | 38393 | 5.2% |
| u | 34239 | 4.6% |
| l | 30362 | 4.1% |
| s | 24885 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287415 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 738553 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 109633 | 14.8% |
| n | 52078 | 7.1% |
| o | 47635 | 6.4% |
| i | 46556 | 6.3% |
| e | 42704 | 5.8% |
| r | 38393 | 5.2% |
| u | 34239 | 4.6% |
| l | 30362 | 4.1% |
| s | 24885 | 3.4% |
| t | 24653 | 3.3% |
| Other values (47) | 287415 |
country_id
Real number (ℝ)
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.85813 |
| Minimum | 1 |
|---|---|
| Maximum | 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 687.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 29 |
| median | 50 |
| Q3 | 80 |
| 95-th percentile | 103 |
| Maximum | 109 |
| Range | 108 |
| Interquartile range (IQR) | 51 |
Descriptive statistics
| Standard deviation | 30.066213 |
|---|---|
| Coefficient of variation (CV) | 0.52879356 |
| Kurtosis | -1.160329 |
| Mean | 56.85813 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 0.056191588 |
| Sum | 5003686 |
| Variance | 903.97716 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 8637 | 9.8% |
| 23 | 7724 | 8.8% |
| 103 | 5428 | 6.2% |
| 50 | 4565 | 5.2% |
| 60 | 4493 | 5.1% |
| 15 | 4058 | 4.6% |
| 80 | 3895 | 4.4% |
| 75 | 3160 | 3.6% |
| 97 | 2094 | 2.4% |
| 45 | 2014 | 2.3% |
| Other values (98) | 41935 |
| Value | Count | Frequency (%) |
| 1 | 109 | 0.1% |
| 2 | 457 | 0.5% |
| 3 | 111 | 0.1% |
| 4 | 301 | 0.3% |
| 5 | 195 | 0.2% |
| 6 | 1884 | |
| 7 | 150 | 0.2% |
| 9 | 403 | 0.5% |
| 10 | 302 | 0.3% |
| 11 | 134 | 0.2% |
| Value | Count | Frequency (%) |
| 109 | 174 | 0.2% |
| 108 | 328 | 0.4% |
| 107 | 628 | 0.7% |
| 106 | 190 | 0.2% |
| 105 | 908 | 1.0% |
| 104 | 963 | 1.1% |
| 103 | 5428 | |
| 102 | 1210 | 1.4% |
| 101 | 476 | 0.5% |
| 100 | 823 | 0.9% |
country
Text
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 29 |
| Mean length | 8.1360181 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Japan |
|---|---|
| 2nd row | Japan |
| 3rd row | Japan |
| 4th row | Japan |
| 5th row | Japan |
| Value | Count | Frequency (%) |
| india | 8637 | 8.0% |
| china | 7724 | 7.2% |
| united | 7114 | 6.6% |
| states | 5428 | 5.0% |
| japan | 4565 | 4.2% |
| mexico | 4493 | 4.2% |
| brazil | 4058 | 3.8% |
| russian | 3895 | 3.6% |
| federation | 3895 | 3.6% |
| philippines | 3160 | 2.9% |
| Other values (122) | 54825 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 95658 | 13.4% |
| i | 80550 | 11.3% |
| n | 72678 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31054 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20016 | 2.8% |
| Other values (44) | 240576 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 715994 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 95658 | 13.4% |
| i | 80550 | 11.3% |
| n | 72678 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31054 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20016 | 2.8% |
| Other values (44) | 240576 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 715994 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 95658 | 13.4% |
| i | 80550 | 11.3% |
| n | 72678 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31054 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20016 | 2.8% |
| Other values (44) | 240576 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 715994 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 95658 | 13.4% |
| i | 80550 | 11.3% |
| n | 72678 | 10.2% |
| e | 58230 | 8.1% |
| t | 35504 | 5.0% |
| r | 31054 | 4.3% |
| d | 30203 | 4.2% |
| o | 26432 | 3.7% |
| s | 25093 | 3.5% |
| l | 20016 | 2.8% |
| Other values (44) | 240576 |
category
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 687.7 KiB |
| Sports | |
|---|---|
| Animation | |
| Action | |
| Documentary | |
| Drama | |
| Other values (11) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 6.5330955 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Classics |
|---|---|
| 2nd row | Classics |
| 3rd row | Classics |
| 4th row | Classics |
| 5th row | Sports |
Common Values
| Value | Count | Frequency (%) |
| Sports | 6936 | 7.9% |
| Animation | 6600 | 7.5% |
| Action | 6307 | 7.2% |
| Documentary | 6188 | 7.0% |
| Drama | 5929 | 6.7% |
| Sci-Fi | 5743 | 6.5% |
| Family | 5631 | 6.4% |
| Foreign | 5559 | 6.3% |
| Children | 5510 | 6.3% |
| New | 5199 | 5.9% |
| Other values (6) | 28401 |
Length
| Value | Count | Frequency (%) |
| sports | 6936 | 7.9% |
| animation | 6600 | 7.5% |
| action | 6307 | 7.2% |
| documentary | 6188 | 7.0% |
| drama | 5929 | 6.7% |
| sci-fi | 5743 | 6.5% |
| family | 5631 | 6.4% |
| foreign | 5559 | 6.3% |
| children | 5510 | 6.3% |
| new | 5199 | 5.9% |
| Other values (6) | 28401 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 57284 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44585 | 7.8% |
| n | 36764 | 6.4% |
| e | 36338 | 6.3% |
| m | 33562 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185602 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 574932 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 57284 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44585 | 7.8% |
| n | 36764 | 6.4% |
| e | 36338 | 6.3% |
| m | 33562 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185602 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 574932 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 57284 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44585 | 7.8% |
| n | 36764 | 6.4% |
| e | 36338 | 6.3% |
| m | 33562 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185602 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 574932 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 57284 | 10.0% |
| r | 49574 | 8.6% |
| o | 46108 | 8.0% |
| a | 44585 | 7.8% |
| n | 36764 | 6.4% |
| e | 36338 | 6.3% |
| m | 33562 | 5.8% |
| s | 31255 | 5.4% |
| c | 27829 | 4.8% |
| t | 26031 | 4.5% |
| Other values (20) | 185602 |
Interactions
Correlations
| active | actor_id | address_id | amount | category | city_id | country_id | customer_id | film_id | inventory_id | length | payment_id | postal_code | rating | rental_duration | rental_id | rental_rate | replacement_cost | staff_fn | staff_id | staff_ln | store_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| active | 1.000 | 0.000 | 0.085 | 0.027 | 0.032 | 0.109 | 0.094 | 0.092 | 0.023 | 0.021 | 0.029 | 0.092 | 0.138 | 0.014 | 0.012 | 0.021 | 0.007 | 0.018 | 0.003 | 0.003 | 0.003 | 0.003 |
| actor_id | 0.000 | 1.000 | 0.001 | -0.007 | 0.056 | 0.002 | 0.001 | 0.001 | 0.015 | 0.015 | 0.015 | 0.001 | 0.004 | 0.043 | 0.041 | -0.004 | 0.043 | -0.001 | 0.000 | 0.000 | 0.000 | 0.000 |
| address_id | 0.085 | 0.001 | 1.000 | 0.014 | 0.032 | 0.042 | -0.042 | 1.000 | -0.003 | -0.003 | -0.014 | 1.000 | -0.043 | 0.019 | 0.028 | -0.003 | 0.027 | -0.022 | 0.076 | 0.076 | 0.076 | 0.076 |
| amount | 0.027 | -0.007 | 0.014 | 1.000 | 0.065 | 0.001 | 0.013 | 0.014 | 0.027 | 0.027 | 0.003 | 0.014 | -0.013 | 0.034 | 0.171 | 0.002 | 0.705 | -0.030 | 0.016 | 0.016 | 0.016 | 0.016 |
| category | 0.032 | 0.056 | 0.032 | 0.065 | 1.000 | 0.033 | 0.029 | 0.032 | 0.139 | 0.138 | 0.149 | 0.031 | 0.029 | 0.155 | 0.161 | 0.024 | 0.145 | 0.141 | 0.030 | 0.030 | 0.030 | 0.030 |
| city_id | 0.109 | 0.002 | 0.042 | 0.001 | 0.033 | 1.000 | -0.059 | 0.042 | 0.009 | 0.009 | -0.002 | 0.042 | -0.071 | 0.020 | 0.021 | -0.005 | 0.026 | -0.001 | 0.104 | 0.104 | 0.104 | 0.104 |
| country_id | 0.094 | 0.001 | -0.042 | 0.013 | 0.029 | -0.059 | 1.000 | -0.042 | 0.017 | 0.017 | 0.012 | -0.042 | 0.001 | 0.024 | 0.021 | -0.005 | 0.020 | 0.004 | 0.102 | 0.102 | 0.102 | 0.102 |
| customer_id | 0.092 | 0.001 | 1.000 | 0.014 | 0.032 | 0.042 | -0.042 | 1.000 | -0.003 | -0.003 | -0.014 | 1.000 | -0.043 | 0.018 | 0.028 | -0.003 | 0.027 | -0.022 | 0.074 | 0.074 | 0.074 | 0.074 |
| film_id | 0.023 | 0.015 | -0.003 | 0.027 | 0.139 | 0.009 | 0.017 | -0.003 | 1.000 | 1.000 | 0.053 | -0.003 | -0.010 | 0.120 | 0.112 | -0.001 | 0.112 | -0.040 | 0.034 | 0.034 | 0.034 | 0.034 |
| inventory_id | 0.021 | 0.015 | -0.003 | 0.027 | 0.138 | 0.009 | 0.017 | -0.003 | 1.000 | 1.000 | 0.053 | -0.003 | -0.010 | 0.119 | 0.112 | -0.001 | 0.116 | -0.040 | 0.033 | 0.033 | 0.033 | 0.033 |
| length | 0.029 | 0.015 | -0.014 | 0.003 | 0.149 | -0.002 | 0.012 | -0.014 | 0.053 | 0.053 | 1.000 | -0.014 | -0.004 | 0.101 | 0.087 | 0.001 | 0.104 | 0.014 | 0.016 | 0.016 | 0.016 | 0.016 |
| payment_id | 0.092 | 0.001 | 1.000 | 0.014 | 0.031 | 0.042 | -0.042 | 1.000 | -0.003 | -0.003 | -0.014 | 1.000 | -0.043 | 0.017 | 0.028 | -0.002 | 0.025 | -0.022 | 0.072 | 0.072 | 0.072 | 0.072 |
| postal_code | 0.138 | 0.004 | -0.043 | -0.013 | 0.029 | -0.071 | 0.001 | -0.043 | -0.010 | -0.010 | -0.004 | -0.043 | 1.000 | 0.017 | 0.015 | 0.006 | 0.026 | -0.001 | 0.090 | 0.090 | 0.090 | 0.090 |
| rating | 0.014 | 0.043 | 0.019 | 0.034 | 0.155 | 0.020 | 0.024 | 0.018 | 0.120 | 0.119 | 0.101 | 0.017 | 0.017 | 1.000 | 0.096 | 0.020 | 0.038 | 0.111 | 0.015 | 0.015 | 0.015 | 0.015 |
| rental_duration | 0.012 | 0.041 | 0.028 | 0.171 | 0.161 | 0.021 | 0.021 | 0.028 | 0.112 | 0.112 | 0.087 | 0.028 | 0.015 | 0.096 | 1.000 | 0.021 | 0.072 | 0.083 | 0.007 | 0.007 | 0.007 | 0.007 |
| rental_id | 0.021 | -0.004 | -0.003 | 0.002 | 0.024 | -0.005 | -0.005 | -0.003 | -0.001 | -0.001 | 0.001 | -0.002 | 0.006 | 0.020 | 0.021 | 1.000 | 0.024 | 0.004 | 0.028 | 0.028 | 0.028 | 0.028 |
| rental_rate | 0.007 | 0.043 | 0.027 | 0.705 | 0.145 | 0.026 | 0.020 | 0.027 | 0.112 | 0.116 | 0.104 | 0.025 | 0.026 | 0.038 | 0.072 | 0.024 | 1.000 | 0.109 | 0.000 | 0.000 | 0.000 | 0.000 |
| replacement_cost | 0.018 | -0.001 | -0.022 | -0.030 | 0.141 | -0.001 | 0.004 | -0.022 | -0.040 | -0.040 | 0.014 | -0.022 | -0.001 | 0.111 | 0.083 | 0.004 | 0.109 | 1.000 | 0.027 | 0.027 | 0.027 | 0.027 |
| staff_fn | 0.003 | 0.000 | 0.076 | 0.016 | 0.030 | 0.104 | 0.102 | 0.074 | 0.034 | 0.033 | 0.016 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_id | 0.003 | 0.000 | 0.076 | 0.016 | 0.030 | 0.104 | 0.102 | 0.074 | 0.034 | 0.033 | 0.016 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_ln | 0.003 | 0.000 | 0.076 | 0.016 | 0.030 | 0.104 | 0.102 | 0.074 | 0.034 | 0.033 | 0.016 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| store_id | 0.003 | 0.000 | 0.076 | 0.016 | 0.030 | 0.104 | 0.102 | 0.074 | 0.034 | 0.033 | 0.016 | 0.072 | 0.090 | 0.015 | 0.007 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
Missing values
Sample
| film_id | title | description | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | staff_id | staff_fn | staff_ln | address_id | address | postal_code | city_id | city | country_id | country | category | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 663 | PATIENT SISTER | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia | 7 | 0.99 | 99 | 29.99 | NC-17 | 90 | SEAN | GUINESS | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 76 | 2005-05-25 11:30:37 | 2005-06-03 12:00:37 | 1 | 2.99 | 2005-05-25 11:30:37 | 3021 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Classics |
| 1 | 663 | PATIENT SISTER | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia | 7 | 0.99 | 99 | 29.99 | NC-17 | 74 | MILLA | KEITEL | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 76 | 2005-05-25 11:30:37 | 2005-06-03 12:00:37 | 1 | 2.99 | 2005-05-25 11:30:37 | 3021 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Classics |
| 2 | 663 | PATIENT SISTER | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia | 7 | 0.99 | 99 | 29.99 | NC-17 | 37 | VAL | BOLGER | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 76 | 2005-05-25 11:30:37 | 2005-06-03 12:00:37 | 1 | 2.99 | 2005-05-25 11:30:37 | 3021 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Classics |
| 3 | 663 | PATIENT SISTER | A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia | 7 | 0.99 | 99 | 29.99 | NC-17 | 20 | LUCILLE | TRACY | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 76 | 2005-05-25 11:30:37 | 2005-06-03 12:00:37 | 1 | 2.99 | 2005-05-25 11:30:37 | 3021 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Classics |
| 4 | 875 | TALENTED HOMICIDE | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat | 6 | 0.99 | 173 | 9.99 | PG | 142 | JADA | RYDER | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 573 | 2005-05-28 10:35:23 | 2005-06-03 06:32:23 | 2 | 0.99 | 2005-05-28 10:35:23 | 4020 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Sports |
| 5 | 875 | TALENTED HOMICIDE | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat | 6 | 0.99 | 173 | 9.99 | PG | 131 | JANE | JACKMAN | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 573 | 2005-05-28 10:35:23 | 2005-06-03 06:32:23 | 2 | 0.99 | 2005-05-28 10:35:23 | 4020 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Sports |
| 6 | 875 | TALENTED HOMICIDE | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat | 6 | 0.99 | 173 | 9.99 | PG | 85 | MINNIE | ZELLWEGER | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 573 | 2005-05-28 10:35:23 | 2005-06-03 06:32:23 | 2 | 0.99 | 2005-05-28 10:35:23 | 4020 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Sports |
| 7 | 875 | TALENTED HOMICIDE | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat | 6 | 0.99 | 173 | 9.99 | PG | 44 | NICK | STALLONE | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 573 | 2005-05-28 10:35:23 | 2005-06-03 06:32:23 | 2 | 0.99 | 2005-05-28 10:35:23 | 4020 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Sports |
| 8 | 875 | TALENTED HOMICIDE | A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat | 6 | 0.99 | 173 | 9.99 | PG | 36 | BURT | DUKAKIS | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 573 | 2005-05-28 10:35:23 | 2005-06-03 06:32:23 | 2 | 0.99 | 2005-05-28 10:35:23 | 4020 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Sports |
| 9 | 611 | MUSKETEERS WAIT | A Touching Yarn of a Student And a Moose who must Fight a Mad Cow in Australia | 7 | 4.99 | 73 | 17.99 | PG | 152 | BEN | HARRIS | 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 1 | 1185 | 2005-06-15 00:54:12 | 2005-06-23 02:42:12 | 3 | 5.99 | 2005-06-15 00:54:12 | 2785 | 1 | 1 | Mike | Hillyer | 5 | 1913 Hanoi Way | 35200 | 463 | Sasebo | 50 | Japan | Classics |
| film_id | title | description | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | staff_id | staff_fn | staff_ln | address_id | address | postal_code | city_id | city | country_id | country | category | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87993 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 158 | VIVIEN | BASINGER | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87994 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 130 | GRETA | KEITEL | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87995 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 112 | RUSSELL | BACALL | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87996 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 85 | MINNIE | ZELLWEGER | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87997 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 70 | MICHELLE | MCCONAUGHEY | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87998 | 869 | SUSPECTS QUILLS | A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse | 4 | 2.99 | 47 | 22.99 | PG | 40 | JOHNNY | CAGE | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15719 | 2005-08-23 11:08:46 | 2005-08-25 07:25:46 | 16048 | 2.99 | 2005-08-23 11:08:46 | 3990 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Action |
| 87999 | 83 | BLUES INSTINCT | A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House | 5 | 2.99 | 50 | 18.99 | G | 181 | MATTHEW | CARREY | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15725 | 2005-08-23 11:25:00 | 2005-08-26 11:46:00 | 16049 | 2.99 | 2005-08-23 11:25:00 | 378 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Family |
| 88000 | 83 | BLUES INSTINCT | A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House | 5 | 2.99 | 50 | 18.99 | G | 122 | SALMA | NOLTE | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15725 | 2005-08-23 11:25:00 | 2005-08-26 11:46:00 | 16049 | 2.99 | 2005-08-23 11:25:00 | 378 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Family |
| 88001 | 83 | BLUES INSTINCT | A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House | 5 | 2.99 | 50 | 18.99 | G | 106 | GROUCHO | DUNST | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15725 | 2005-08-23 11:25:00 | 2005-08-26 11:46:00 | 16049 | 2.99 | 2005-08-23 11:25:00 | 378 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Family |
| 88002 | 83 | BLUES INSTINCT | A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House | 5 | 2.99 | 50 | 18.99 | G | 24 | CAMERON | STREEP | 599 | AUSTIN | CINTRON | AUSTIN.CINTRON@sakilacustomer.org | 1 | 15725 | 2005-08-23 11:25:00 | 2005-08-26 11:46:00 | 16049 | 2.99 | 2005-08-23 11:25:00 | 378 | 2 | 2 | Jon | Stephens | 605 | 1325 Fukuyama Street | 27107 | 537 | Tieli | 23 | China | Family |